USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[UsersUpdateLastLogin]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.UsersUpdateLastLogin
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 11/04/08
-- Description:	Users Table Update LastLogin
-- =============================================
CREATE PROCEDURE UsersUpdateLastLogin

	@Login varchar(30),
	@LastLogin datetime

AS
BEGIN

UPDATE Users
SET LastLogin = @LastLogin
WHERE [Login] = @Login

END
GO

